
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_app
-- ----------------------------
DROP TABLE IF EXISTS `sys_app`;
CREATE TABLE `sys_app` (
  `id` bigint NOT NULL COMMENT '主键id',
  `name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '应用名称',
  `code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '应用编码',
  `sort` int DEFAULT '0' COMMENT '排序',
  `icon` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '图标',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '修改人',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='系统应用表';

-- ----------------------------
-- Records of sys_app
-- ----------------------------
BEGIN;
INSERT INTO `sys_app` (`id`, `name`, `code`, `sort`, `icon`, `create_time`, `create_by`, `update_time`, `update_by`,`del_flag`) VALUES (1, '系统应用', 'system', 1, 'laptop', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', 'admin','0');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门ID',
  `parent_id` bigint NOT NULL COMMENT '上级部门ID',
  `dept_code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '部门编码',
  `dept_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '部门名称',
  `sort_order` double(20,0) DEFAULT NULL COMMENT '排序',
   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `create_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (0, -1,'0001', '总裁办', 0, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (1, 0, '0002','技术部', 0, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (2, 0, '0003','市场部', 0, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (3, 0, '0004','销售部', 0, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (4, 0, '0005','财务部', 0, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (5, 0, '0006','人事部', 0, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (6, 1, '0007','研发部', 1, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (7, 1, '0008','产品部', 2, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_code`,`dept_name`, `sort_order`, `create_time`, `update_time`, `create_by`, `update_by`,`del_flag`) VALUES (8, 0, '0009','风险部', 0, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin','0');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典类型',
  `description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '修改人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注信息',
  `system_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '系统标志',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
  PRIMARY KEY (`dict_id`) USING BTREE,
  KEY `sys_dict_del_flag` (`del_flag`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典表';
-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (1, 'log_type', '日志类型', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '异常、正常', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (2, 'social_type', '社交登录', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '微信、QQ', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (3, 'job_type', '定时任务类型', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'quartz', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (4, 'job_status', '定时任务状态', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '发布状态、运行状态', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (5, 'job_execute_status', '定时任务执行状态', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '正常、异常', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (6, 'misfire_policy', '定时任务错失执行策略', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '周期', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (7, 'gender', '性别', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '微信用户性别', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (8, 'subscribe', '订阅状态', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '公众号订阅状态', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (9, 'response_type', '回复', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '微信消息是否已回复', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (10, 'param_type', '参数配置', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '检索、原文、报表、安全、文档、消息、其他', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (11, 'status_type', '租户状态', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '租户状态', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (12, 'dict_type', '字典类型', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '系统类不能修改', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (13, 'channel_type', '支付类型', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '系统类不能修改', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (14, 'grant_types', '授权类型', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (15, 'style_type', '前端风格', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '0-Avue 1-element', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (16, 'captcha_flag_types', '验证码开关', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '是否校验验证码', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (17, 'enc_flag_types', '前端密码加密', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '前端密码是否加密传输', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (18, 'lock_flag', '用户状态', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (19, 'ds_config_type', '数据连接类型', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (20, 'common_status', '通用状态', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (21, 'app_social_type', 'app社交登录', 'admin', ' ', '2025-03-06 09:00:00', NULL, 'app社交登录', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (22, 'yes_no_type', '是否', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (23, 'repType', '微信消息类型', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (24, 'leave_status', '请假状态', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (25, 'schedule_type', '日程类型', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (26, 'schedule_status', '日程状态', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (27, 'ds_type', '代码生成器支持的数据库类型', 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (28, 'job_run_type', '定时任务运行类型', 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '定时任务串行并行执行', '0', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (29, 'driver_class_name', '数据库驱动类', 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '数据库驱动类', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (30, 'LLM_MODEL_TYPE', 'llm模型类型', 'admin', 'admin', '2025-06-16 15:34:17', '2025-06-16 15:34:17', '', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (31, 'LLM_PROVIDER', 'LLM供应商', 'admin', 'admin', '2025-06-16 16:06:21', '2025-06-16 16:06:21', 'Ai供应商', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (32, 'LLM_IMAGE_SIZE', 'LLM图片大小', 'admin', 'admin', '2025-06-18 11:11:26', '2025-06-18 11:11:26', '', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (33, 'LLM_IMAGE_QUANTITY', 'LLM图片质量', 'admin', 'admin', '2025-06-18 11:13:55', '2025-06-18 11:13:55', '', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (34, 'LLM_IMAGE_STYLE', 'LLM图片风格', 'admin', 'admin', '2025-06-18 11:17:13', '2025-06-18 11:17:13', '', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (35, 'llm_embedStore_provider', 'LLM向量存储数据库类型', 'admin', 'admin', '2025-06-18 15:22:49', '2025-06-18 15:22:49', '', '1', '0');
INSERT INTO `sys_dict` (`dict_id`, `dict_type`, `description`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `system_flag`, `del_flag`) VALUES (36, 'LLM_PROVIDER_URL', '模型供应商基础地址', 'admin', 'admin', '2025-09-12 09:07:04', '2025-09-12 09:07:04', '', '0', '0');

COMMIT;

-- ----------------------------
-- Table structure for sys_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_item`;
CREATE TABLE `sys_dict_item` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `dict_id` bigint NOT NULL COMMENT '字典ID',
  `item_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典项值',
  `label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典项名称',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典类型',
  `description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典项描述',
  `sort_order` int NOT NULL DEFAULT '0' COMMENT '排序（升序）',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '修改人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注信息',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `sys_dict_value` (`item_value`) USING BTREE,
  KEY `sys_dict_label` (`label`) USING BTREE,
  KEY `sys_dict_item_del_flag` (`del_flag`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典项';

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (1, 1, '9', '异常', 'log_type', '日志异常', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (2, 1, '0', '正常', 'log_type', '日志正常', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (3, 2, 'WX', '微信', 'social_type', '微信登录', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (4, 2, 'QQ', 'QQ', 'social_type', 'QQ登录', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (5, 3, '1', 'java类', 'job_type', 'java类', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (6, 3, '2', 'spring bean', 'job_type', 'spring bean容器实例', 2, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (7, 3, '9', '其他', 'job_type', '其他类型', 9, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (8, 3, '3', 'Rest 调用', 'job_type', 'Rest 调用', 3, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (9, 3, '4', 'jar', 'job_type', 'jar类型', 4, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (10, 4, '1', '未发布', 'job_status', '未发布', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (11, 4, '2', '运行中', 'job_status', '运行中', 2, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (12, 4, '3', '暂停', 'job_status', '暂停', 3, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (13, 5, '0', '正常', 'job_execute_status', '正常', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (14, 5, '1', '异常', 'job_execute_status', '异常', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (15, 6, '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (16, 6, '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', 2, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (17, 6, '3', '下周期执行', 'misfire_policy', '下周期执行', 3, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (18, 7, '1', '男', 'gender', '微信-男', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '微信-男', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (19, 7, '2', '女', 'gender', '女-微信', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '女-微信', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (20, 7, '0', '未知', 'gender', 'x性别未知', 3, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'x性别未知', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (21, 8, '0', '未关注', 'subscribe', '公众号-未关注', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '公众号-未关注', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (22, 8, '1', '已关注', 'subscribe', '公众号-已关注', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '公众号-已关注', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (23, 9, '0', '未回复', 'response_type', '微信消息-未回复', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '微信消息-未回复', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (24, 9, '1', '已回复', 'response_type', '微信消息-已回复', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '微信消息-已回复', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (25, 10, '1', '检索', 'param_type', '检索', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '检索', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (26, 10, '2', '原文', 'param_type', '原文', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '原文', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (27, 10, '3', '报表', 'param_type', '报表', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '报表', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (28, 10, '4', '安全', 'param_type', '安全', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '安全', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (29, 10, '5', '文档', 'param_type', '文档', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '文档', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (30, 10, '6', '消息', 'param_type', '消息', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '消息', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (31, 10, '9', '其他', 'param_type', '其他', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '其他', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (32, 10, '0', '默认', 'param_type', '默认', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '默认', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (33, 11, '0', '正常', 'status_type', '状态正常', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '状态正常', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (34, 11, '9', '冻结', 'status_type', '状态冻结', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '状态冻结', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (35, 12, '1', '系统类', 'dict_type', '系统类字典', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '不能修改删除', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (36, 12, '0', '业务类', 'dict_type', '业务类字典', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '可以修改', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (37, 2, 'GITEE', '码云', 'social_type', '码云', 2, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '码云', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (38, 2, 'OSC', '开源中国', 'social_type', '开源中国登录', 2, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (39, 14, 'password', '密码模式', 'grant_types', '支持oauth密码模式', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (40, 14, 'authorization_code', '授权码模式', 'grant_types', 'oauth2 授权码模式', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (41, 14, 'client_credentials', '客户端模式', 'grant_types', 'oauth2 客户端模式', 2, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (42, 14, 'refresh_token', '刷新模式', 'grant_types', 'oauth2 刷新token', 3, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (43, 14, 'implicit', '简化模式', 'grant_types', 'oauth2 简化模式', 4, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (44, 15, '0', 'Avue', 'style_type', 'Avue风格', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (45, 15, '1', 'element', 'style_type', 'element-ui', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (46, 16, '0', '关', 'captcha_flag_types', '不校验验证码', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '不校验验证码 -0', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (47, 16, '1', '开', 'captcha_flag_types', '校验验证码', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '不校验验证码-1', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (48, 17, '0', '否', 'enc_flag_types', '不加密', 0, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '不加密-0', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (49, 17, '1', '是', 'enc_flag_types', '加密', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '加密-1', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (50, 13, 'MERGE_PAY', '聚合支付', 'channel_type', '聚合支付', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '聚合支付', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (51, 2, 'CAS', 'CAS登录', 'social_type', 'CAS 单点登录系统', 3, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (52, 2, 'DINGTALK', '钉钉', 'social_type', '钉钉', 3, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (53, 2, 'WEIXIN_CP', '企业微信', 'social_type', '企业微信', 3, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (54, 15, '2', 'APP', 'style_type', 'uview风格', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (55, 13, 'ALIPAY_WAP', '支付宝支付', 'channel_type', '支付宝支付', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '聚合支付', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (56, 13, 'WEIXIN_MP', '微信支付', 'channel_type', '微信支付', 1, ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '聚合支付', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (57, 14, 'mobile', 'mobile', 'grant_types', '移动端登录', 5, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (58, 18, '0', '有效', 'lock_flag', '有效', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (59, 18, '9', '禁用', 'lock_flag', '禁用', 1, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (60, 15, '4', 'vue3', 'style_type', 'element-plus', 4, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (61, 19, '0', '主机', 'ds_config_type', '主机', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (62, 19, '1', 'JDBC', 'ds_config_type', 'jdbc', 2, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (63, 20, 'false', '否', 'common_status', '否', 1, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (64, 20, 'true', '是', 'common_status', '是', 2, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (65, 21, 'MINI', '小程序', 'app_social_type', '小程序登录', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (66, 22, '0', '否', 'yes_no_type', '0', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, '0', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (67, 22, '1', '是', 'yes_no_type', '1', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, '1', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (69, 23, 'text', '文本', 'repType', '文本', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (70, 23, 'image', '图片', 'repType', '图片', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (71, 23, 'voice', '语音', 'repType', '语音', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (72, 23, 'video', '视频', 'repType', '视频', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (73, 23, 'shortvideo', '小视频', 'repType', '小视频', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (74, 23, 'location', '地理位置', 'repType', '地理位置', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (75, 23, 'link', '链接消息', 'repType', '链接消息', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (76, 23, 'event', '事件推送', 'repType', '事件推送', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (77, 24, '0', '未提交', 'leave_status', '未提交', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, '未提交', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (78, 24, '1', '审批中', 'leave_status', '审批中', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, '审批中', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (79, 24, '2', '完成', 'leave_status', '完成', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, '完成', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (80, 24, '9', '驳回', 'leave_status', '驳回', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (81, 25, 'record', '日程记录', 'schedule_type', '日程记录', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (82, 25, 'plan', '计划', 'schedule_type', '计划类型', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (83, 26, '0', '计划中', 'schedule_status', '日程状态', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (84, 26, '1', '已开始', 'schedule_status', '已开始', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (85, 26, '3', '已结束', 'schedule_status', '已结束', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (86, 27, 'mysql', 'mysql', 'ds_type', 'mysql', 0, 'admin', ' ', '2025-03-06 09:00:00', NULL, NULL, '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (87, 28, '0', '串行', 'job_run_type', '串行任务', 0, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (88, 28, '1', '并行', 'job_run_type', '并行任务', 1, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (89, 27, 'mssql', 'mssql', 'ds_type', 'SQL Server数据库', 1, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'SQL Server数据库', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (90, 27, 'oracle', 'oracle', 'ds_type', 'oracle数据库', 2, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'oracle数据库', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (91, 27, 'dm', 'dm', 'ds_type', '达梦数据库', 3, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '达梦数据库', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (92, 27, 'db2', 'db2', 'ds_type', 'DB2数据库', 4, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'DB2数据库', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (93, 27, 'pg', 'postgresql', 'ds_type', 'postgresql数据库', 5, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'postgresql数据库', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (94, 27, 'highgo', 'highgo', 'ds_type', '瀚高数据库', 6, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '瀚高数据库', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (95, 29, 'mysql', 'com.mysql.cj.jdbc.Driver', 'driver_class_name', 'mysql驱动类', 0, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'mysql驱动类', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (96, 29, 'mssql', 'com.microsoft.sqlserver.jdbc.SQLServerDriver', 'driver_class_name', 'SQL Server数据库驱动', 1, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'SQL Server数据库驱动', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (97, 29, 'oracle', 'oracle.jdbc.driver.OracleDriver', 'driver_class_name', 'oracle数据库驱动', 2, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'oracle数据库驱动', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (98, 29, 'pg', 'org.postgresql.Driver', 'driver_class_name', 'PostgreSql数据库驱动', 3, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'PostgreSql数据库驱动', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (99, 29, 'dm', 'dm.jdbc.driver.DmDriver', 'driver_class_name', '达梦数据库驱动', 4, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '达梦数据库驱动', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (100, 29, 'db2', 'com.ibm.db2.jcc.DB2Driver', 'driver_class_name', 'DB2数据库驱动', 5, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'DB2数据库驱动', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (101, 29, 'highgo', 'com.highgo.jdbc.Driver', 'driver_class_name', '瀚高数据库驱动', 5, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '瀚高数据库驱动', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (102, 30, '1', '聊天', 'LLM_MODEL_TYPE', '聊天模式', 0, 'admin', 'admin', '2025-06-16 15:35:06', '2025-06-16 15:35:06', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (103, 30, '2', '嵌入', 'LLM_MODEL_TYPE', '嵌入模式', 1, 'admin', 'admin', '2025-06-16 15:35:27', '2025-06-16 15:35:27', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (104, 30, '3', '文生图', 'LLM_MODEL_TYPE', '文生图模式', 2, 'admin', 'admin', '2025-06-16 15:35:54', '2025-06-16 15:35:54', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (105, 31, 'openai', 'OPEN-AI', 'LLM_PROVIDER', 'OpenAI', 0, 'admin', 'admin', '2025-06-16 16:07:37', '2025-06-16 16:07:37', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (106, 31, 'doubao', '抖音', 'LLM_PROVIDER', '抖音', 1, 'admin', 'admin', '2025-06-16 16:08:25', '2025-06-16 16:08:25', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (107, 31, 'zhipu', '智普', 'LLM_PROVIDER', '智普', 2, 'admin', 'admin', '2025-06-16 16:09:28', '2025-06-16 16:09:28', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (108, 31, 'deepseek', 'DeepSeek', 'LLM_PROVIDER', 'DeepSeek', 3, 'admin', 'admin', '2025-06-16 16:09:49', '2025-06-16 16:09:49', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (109, 31, 'ollama', 'Ollama', 'LLM_PROVIDER', 'Ollama', 4, 'admin', 'admin', '2025-06-16 16:10:05', '2025-06-16 16:10:05', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (110, 32, '1024x1024', '1024x1024', 'LLM_IMAGE_SIZE', '1024x1024', 0, 'admin', 'admin', '2025-06-18 11:11:56', '2025-06-18 11:11:56', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (111, 32, '1024x1792', '1024x1792', 'LLM_IMAGE_SIZE', '1024x1792', 1, 'admin', 'admin', '2025-06-18 11:12:08', '2025-06-18 11:12:08', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (112, 32, '1792x1024', '1792x1024', 'LLM_IMAGE_SIZE', '1792x1024', 2, 'admin', 'admin', '2025-06-18 11:12:20', '2025-06-18 11:12:20', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (113, 33, 'standard', '标准质量', 'LLM_IMAGE_QUANTITY', '标准质量', 0, 'admin', 'admin', '2025-06-18 11:14:27', '2025-06-18 11:14:27', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (114, 33, 'hd', '增强', 'LLM_IMAGE_QUANTITY', '增强细节的质量', 1, 'admin', 'admin', '2025-06-18 11:14:27', '2025-06-18 11:14:27', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (115, 34, 'vivid', 'vivid', 'LLM_IMAGE_STYLE', 'vivid', 0, 'admin', 'admin', '2025-06-18 11:14:27', '2025-06-18 11:14:27', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (116, 34, 'natural', 'natural', 'LLM_IMAGE_STYLE', 'natural', 1, 'admin', 'admin', '2025-06-18 11:14:27', '2025-06-18 11:14:27', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (117, 35, 'Redis', 'Redis', 'llm_embedStore_provider', 'Redis数据库', 0, 'admin', 'admin', '2025-06-18 15:24:42', '2025-06-18 15:24:42', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (118, 35, 'PgVector', 'PgVector', 'llm_embedStore_provider', 'PgVector', 1, 'admin', 'admin', '2025-06-18 15:26:34', '2025-06-18 15:26:34', 'PGVector是一个高效的向量数据库插件，支持多种向量计算算法和数据类型，同时还能够高效存储与查询以向量表示的AI Embedding', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (119, 35, 'Milvus', 'Milvus', 'llm_embedStore_provider', 'Milvus', 2, 'admin', 'admin', '2025-06-18 15:36:43', '2025-06-18 15:36:43', 'Milvus 是一个开源的、高性能的向量数据库,专为海量向量数据的快速检索而设计。', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (120, 35, 'ElasticSearch', 'ElasticSearch', 'llm_embedStore_provider', 'ElasticSearch', 3, 'admin', 'admin', '2025-06-18 15:37:28', '2025-06-18 15:37:28', '‌Elasticsearch（ES）‌ 是一个基于Lucene构建的分布式、高扩展、实时搜索与分析引擎，属于Elastic Stack（原ELK Stack）的核心组件。', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (121, 36, 'openai', 'https://api.openai.com/v1', 'LLM_PROVIDER_URL', 'openai基础地址', 0, 'admin', 'admin', '2025-09-12 09:14:35', '2025-09-12 09:14:35', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (122, 36, 'deepseek', 'https://api.deepseek.com/v1', 'LLM_PROVIDER_URL', 'deepseek官方URL地址', 1, 'admin', 'admin', '2025-09-12 09:15:24', '2025-09-12 09:15:24', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (123, 36, 'ollama', 'http://localhost:11434/v1', 'LLM_PROVIDER_URL', 'ollama基础地址', 2, 'admin', 'admin', '2025-09-12 09:16:46', '2025-09-12 09:16:46', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (124, 36, 'zhipu', 'https://open.bigmodel.cn/api/paas/v4/', 'LLM_PROVIDER_URL', 'zhipu基础地址', 3, 'admin', 'admin', '2025-09-12 09:17:53', '2025-09-12 09:23:57', '', '0');
INSERT INTO `sys_dict_item` (`id`, `dict_id`, `item_value`, `label`, `dict_type`, `description`, `sort_order`, `create_by`, `update_by`, `create_time`, `update_time`, `remarks`, `del_flag`) VALUES (125, 36, 'doubao', 'https://ark.cn-beijing.volces.com/api/v3', 'LLM_PROVIDER_URL', 'doubao火山引擎方舟平台专用端点', 4, 'admin', 'admin', '2025-09-12 09:17:53', '2025-09-12 09:17:53', '', '0');

COMMIT;


-- ----------------------------
-- Table structure for sys_public_param
-- ----------------------------
DROP TABLE IF EXISTS `sys_public_param`;
CREATE TABLE `sys_public_param` (
  `public_id` bigint NOT NULL COMMENT '编号',
  `public_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `public_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '键',
  `public_value` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '值',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态，0禁用，1启用',
  `validate_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '校验码',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '修改人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `public_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '类型，0未知，1系统，2业务',
  `system_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '系统标识，0非系统，1系统',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`public_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='公共参数配置表';

-- ----------------------------
-- Records of sys_public_param
-- ----------------------------
BEGIN;
INSERT INTO `sys_public_param` VALUES (1, '租户默认来源', 'TENANT_DEFAULT_ID', '1', '0', '', ' ', ' ', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '2', '0', '1');
INSERT INTO `sys_public_param` VALUES (2, '租户默认部门名称', 'TENANT_DEFAULT_DEPTNAME', '租户默认部门', '0', '', ' ', ' ', '2025-03-06 09:00:00', NULL, '2', '1', '0');
INSERT INTO `sys_public_param` VALUES (3, '租户默认账户', 'TENANT_DEFAULT_USERNAME', 'admin', '0', '', ' ', ' ', '2025-03-06 09:00:00', NULL, '2', '1', '0');
INSERT INTO `sys_public_param` VALUES (4, '租户默认密码', 'TENANT_DEFAULT_PASSWORD', '123456', '0', '', ' ', ' ', '2025-03-06 09:00:00', NULL, '2', '1', '0');
INSERT INTO `sys_public_param` VALUES (5, '租户默认角色编码', 'TENANT_DEFAULT_ROLECODE', 'ROLE_ADMIN', '0', '', ' ', ' ', '2025-03-06 09:00:00', NULL, '2', '1', '0');
INSERT INTO `sys_public_param` VALUES (6, '租户默认角色名称', 'TENANT_DEFAULT_ROLENAME', '租户默认角色', '0', '', ' ', ' ', '2025-03-06 09:00:00', NULL, '2', '1', '0');
INSERT INTO `sys_public_param` VALUES (7, '表前缀', 'GEN_TABLE_PREFIX', 'tb_', '0', '', ' ', ' ', '2025-03-06 09:00:00', NULL, '9', '1', '0');
INSERT INTO `sys_public_param` VALUES (8, '接口文档不显示的字段', 'GEN_HIDDEN_COLUMNS', 'tenant_id', '0', '', ' ', ' ', '2025-03-06 09:00:00', NULL, '9', '1', '0');
INSERT INTO `sys_public_param` VALUES (9, '注册用户默认角色', 'USER_DEFAULT_ROLE', 'GENERAL_USER', '0', NULL, ' ', ' ', '2025-03-06 09:00:00', NULL, '2', '1', '0');
COMMIT;
-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `id` bigint NOT NULL,
  `file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bucket_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `original` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_size` bigint DEFAULT NULL COMMENT '文件大小',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '0-正常，1-删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文件管理表';

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint NOT NULL COMMENT '菜单ID',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单名称',
  `en_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '英文名称',
  `permission` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限标识',
  `path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '路由路径',
  `parent_id` bigint DEFAULT NULL COMMENT '父菜单ID',
  `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单图标',
  `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '是否可见，0隐藏，1显示',
  `sort_order` int DEFAULT '1' COMMENT '排序值，越小越靠前',
  `keep_alive` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否缓存，0否，1是',
  `embedded` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否内嵌，0否，1是',
  `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '菜单类型，0目录，1菜单，2按钮',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '创建人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '修改人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志，0未删除，1已删除',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1000, '权限管理', 'authorization', NULL, '/admin', 0, 'iconfont icon-icon-', '1', 0, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1100, '用户管理', 'user', NULL, '/admin/user/index', 1000, 'ele-User', '1', 1, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1101, '用户新增', NULL, 'sys_user_add', NULL, 1100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1102, '用户修改', NULL, 'sys_user_edit', NULL, 1100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1103, '用户删除', NULL, 'sys_user_del', NULL, 1100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1104, '导入导出', NULL, 'sys_user_export', NULL, 1100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1200, '菜单管理', 'menu', NULL, '/admin/menu/index', 1000, 'iconfont icon-caidan', '1', 2, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1201, '菜单新增', NULL, 'sys_menu_add', NULL, 1200, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1202, '菜单修改', NULL, 'sys_menu_edit', NULL, 1200, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1203, '菜单删除', NULL, 'sys_menu_del', NULL, 1200, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1300, '角色管理', 'role', NULL, '/admin/role/index', 1000, 'iconfont icon-gerenzhongxin', '1', 3, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1301, '角色新增', NULL, 'sys_role_add', NULL, 1300, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1302, '角色修改', NULL, 'sys_role_edit', NULL, 1300, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1303, '角色删除', NULL, 'sys_role_del', NULL, 1300, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1304, '分配权限', NULL, 'sys_role_perm', NULL, 1300, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1305, '角色导入导出', NULL, 'sys_role_export', NULL, 1300, NULL, '1', 4, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1400, '部门管理', 'dept', NULL, '/admin/dept/index', 1000, 'iconfont icon-zidingyibuju', '1', 4, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1401, '部门新增', NULL, 'sys_dept_add', NULL, 1400, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1402, '部门修改', NULL, 'sys_dept_edit', NULL, 1400, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1403, '部门删除', NULL, 'sys_dept_del', NULL, 1400, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1600, '岗位管理', 'post', NULL, '/admin/post/index', 1000, 'iconfont icon--chaifenhang', '1', 5, '1', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1601, '岗位信息查看', NULL, 'sys_post_view', NULL, 1600, NULL, '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1602, '岗位信息新增', NULL, 'sys_post_add', NULL, 1600, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1603, '岗位信息修改', NULL, 'sys_post_edit', NULL, 1600, NULL, '1', 2, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1604, '岗位信息删除', NULL, 'sys_post_del', NULL, 1600, NULL, '1', 3, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1605, '岗位导入导出', NULL, 'sys_post_export', NULL, 1600, NULL, '1', 4, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1700, '路由管理', 'routeConf', NULL, '/admin/route/index', 1000, 'iconfont icon-quanjushezhi_o', '1', 6, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1701, '新增', 'add', 'sys_route_add', '', 1700, '', '1', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1702, '修改', 'update', 'sys_route_update', '', 1700, '', '1', 1, '0', '0', '1', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1703, '删除', 'delete', 'sys_route_delete', '', 1700, '', '1', 2, '0', '0', '1', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1704, '查看', 'view', 'sys_route_view', '', 1700, '', '1', 3, '0', '0', '1', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1705, '导出', 'export', 'sys_route_export', '', 1700, 'iconfont icon--chaifenhang', '1', 4, '0', '0', '1', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1800, '路由列表', 'routeList', '', '/admin/route/table', 1000, 'iconfont icon-quanjushezhi_o', '1', 7, '0', '0', '0', 'admin', '2025-09-19 16:29:09', 'admin', '2025-09-23 09:43:07', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2000, '系统管理', 'system', NULL, '/system', 0, 'iconfont icon-quanjushezhi_o', '1', 1, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2001, '日志管理', 'log', NULL, '/admin/logs', 2000, 'ele-Cloudy', '1', 0, '0', '0', '0', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2100, '操作日志', 'operation', NULL, '/admin/log/index', 2001, 'iconfont icon-jinridaiban', '1', 2, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2101, '日志删除', NULL, 'sys_log_del', NULL, 2100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2102, '导入导出', NULL, 'sys_log_export', NULL, 2100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2200, '字典管理', 'dict', NULL, '/admin/dict/index', 2000, 'iconfont icon-zhongduancanshuchaxun', '1', 6, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2201, '字典删除', NULL, 'sys_dict_del', NULL, 2200, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2202, '字典新增', NULL, 'sys_dict_add', NULL, 2200, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2203, '字典修改', NULL, 'sys_dict_edit', NULL, 2200, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2210, '参数管理', 'parameter', NULL, '/admin/param/index', 2000, 'iconfont icon-wenducanshu-05', '1', 7, '1', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2211, '参数新增', NULL, 'sys_params_add', NULL, 2210, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2212, '参数删除', NULL, 'sys_params_delete', NULL, 2210, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2213, '参数编辑', NULL, 'sys_params_edit', NULL, 2210, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2214, '参数导出', NULL, 'sys_params_export', NULL, 2210, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2215, '参数同步', NULL, 'sys_params_sync', NULL, 2210, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2300, '代码生成', 'code', NULL, '/gen/table/index', 9000, 'iconfont icon-zhongduancanshu', '1', 1, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2400, '终端管理', 'client', NULL, '/admin/client/index', 2000, 'iconfont icon-gongju', '1', 9, '1', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2401, '客户端新增', NULL, 'sys_client_add', NULL, 2400, '1', '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2402, '客户端修改', NULL, 'sys_client_edit', NULL, 2400, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2403, '客户端删除', NULL, 'sys_client_del', NULL, 2400, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2600, '令牌管理', 'token', NULL, '/admin/token/index', 2000, 'ele-Key', '1', 11, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2601, '令牌删除', NULL, 'sys_token_del', NULL, 2600, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2800, 'Quartz管理', 'quartz', NULL, '/daemon/job-manage/index', 2000, 'ele-AlarmClock', '1', 8, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2810, '任务新增', NULL, 'sys_job_add', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2820, '任务修改', NULL, 'sys_job_update', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2830, '任务删除', NULL, 'sys_job_delete', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2840, '任务暂停', NULL, 'sys_job_stop', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2841, '任务全部停止', NULL, 'sys_job_stopAll', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2850, '任务开始', NULL, 'sys_job_start', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2851, '任务全部开始', NULL, 'sys_job_startAll', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2860, '任务刷新', NULL, 'sys_job_refresh', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2870, '执行任务', NULL, 'sys_job_run', NULL, 2800, '1', '1', 0, '0', NULL, '1', ' ', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2871, '导出', NULL, 'sys_job_export', NULL, 2800, NULL, '1', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2906, '文件管理', 'file', NULL, '/admin/file/index', 2000, 'ele-Files', '1', 6, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2907, '删除文件', NULL, 'sys_file_del', NULL, 2906, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4000, '系统监控', 'monitor', NULL, '/daemon', 0, 'iconfont icon-shuju', '1', 3, '0', '0', '0', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4001, '文档扩展', 'doc', NULL, '/ext/doc-manage', 4000, 'iconfont icon-biaodan', '1', 2, '0', '1', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4002, '缓存监控', 'cache', NULL, '/ext/cache', 4000, 'iconfont icon-shuju', '1', 1, '0', '0', '0', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9000, '开发平台', 'develop', NULL, '/gen', 0, 'iconfont icon-shuxingtu', '1', 9, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9005, '数据源管理', 'datasource', NULL, '/gen/datasource/index', 9000, 'ele-Coin', '1', 0, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9006, '表单设计', 'Form Design', NULL, '/gen/design/index', 9000, 'iconfont icon-AIshiyanshi', '0', 2, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9007, '生成页面', 'generation', NULL, '/gen/gener/index', 9000, 'iconfont icon-tongzhi4', '0', 0, '0', '0', '0', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9050, '元数据管理', 'metadata', NULL, '/gen/metadata', 9000, 'iconfont icon--chaifenhang', '1', 9, '0', '0', '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9051, '模板管理', 'template', NULL, '/gen/template/index', 9050, 'iconfont icon--chaifenhang', '1', 5, '0', '0', '0', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9052, '查询', NULL, 'codegen_template_view', NULL, 9051, NULL, '0', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9053, '增加', NULL, 'codegen_template_add', NULL, 9051, NULL, '1', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9054, '新增', NULL, 'codegen_template_add', NULL, 9051, NULL, '0', 1, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9055, '导出', NULL, 'codegen_template_export', NULL, 9051, NULL, '0', 2, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9056, '删除', NULL, 'codegen_template_del', NULL, 9051, NULL, '0', 3, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9057, '编辑', NULL, 'codegen_template_edit', NULL, 9051, NULL, '0', 4, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9059, '模板分组', 'group', NULL, '/gen/group/index', 9050, 'iconfont icon-shuxingtu', '1', 6, '0', '0', '0', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9060, '查询', NULL, 'codegen_group_view', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9061, '新增', NULL, 'codegen_group_add', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9062, '修改', NULL, 'codegen_group_edit', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9063, '删除', NULL, 'codegen_group_del', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9064, '导出', NULL, 'codegen_group_export', NULL, 9059, NULL, '0', 0, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9065, '字段管理', 'field', NULL, '/gen/field-type/index', 9050, 'iconfont icon-fuwenben', '1', 0, '0', '0', '0', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5000, 'Aigc管理', 'aigc', '', '/aigc', 0, 'fa fa-firefox', '1', 5, '0', '0', '0', 'admin', '2025-07-08 11:21:23', 'admin', '2025-07-08 03:21:42', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5010, '供应商模型管理', 'provider', NULL, '/aigc/providerModel/index', 5000, 'iconfont icon-gerenzhongxin', '1', 1, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-07-08 15:49:50', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5011, '新增', NULL, 'aigc_provider_model_add', NULL, 5010, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5012, '修改', NULL, 'aigc_provider_model_edit', NULL, 5010, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5013, '删除', NULL, 'aigc_provider_model_delete', NULL, 5010, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5014, '导出', NULL, 'aigc_provider_model_export', NULL, 5010, NULL, '0', 2, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5020, '模型管理', 'model', NULL, '/aigc/model/index', 5000, 'iconfont icon-gerenzhongxin', '1', 2, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-07-08 15:50:10', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5021, '新增', NULL, 'aigc_model_add', NULL, 5020, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5022, '修改', NULL, 'aigc_model_edit', NULL, 5020, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5023, '删除', NULL, 'aigc_model_delete', NULL, 5020, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5024, '导出', NULL, 'aigc_model_export', NULL, 5020, NULL, '0', 2, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5030, '提示词管理', 'prompt', NULL, '/aigc/app/index', 5000, 'iconfont icon-gerenzhongxin', '1', 4, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-07-08 15:53:54', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5031, '新增', NULL, 'aigc_app_add', NULL, 5030, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5032, '修改', NULL, 'aigc_app_edit', NULL, 5030, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5033, '删除', NULL, 'aigc_app_delete', NULL, 5030, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5034, '导出', NULL, 'aigc_app_export', NULL, 5030, NULL, '0', 2, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5040, '应用管理', 'app', NULL, '/aigc/appApi/index', 5000, 'iconfont icon-gerenzhongxin', '0', 5, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-07-08 15:54:12', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5041, '新增', NULL, 'aigc_app_api_add', NULL, 5040, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5042, '修改', NULL, 'aigc_app_api_edit', NULL, 5040, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5043, '删除', NULL, 'aigc_app_api_delete', NULL, 5040, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5050, '会话管理', 'conversation', NULL, '/aigc/conversation/index', 5000, 'iconfont icon-gerenzhongxin', '1', 8, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-07-08 15:55:14', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5051, '新增', NULL, 'aigc_conversation_add', NULL, 5050, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5052, '修改', NULL, 'aigc_conversation_edit', NULL, 5050, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5053, '删除', NULL, 'aigc_conversation_delete', NULL, 5050, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5054, '导出', NULL, 'aigc_conversation_export', NULL, 5050, NULL, '0', 2, '0', '0', '1', 'admin', '2025-03-06 09:00:00', ' ', NULL, '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5060, '向量库管理', 'embedStore', NULL, '/aigc/embedStore/index', 5000, 'iconfont icon-gerenzhongxin', '1', 3, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5061, '新增', NULL, 'aigc_embed_store_add', NULL, 5060, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5062, '修改', NULL, 'aigc_embed_store_edit', NULL, 5060, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5063, '删除', NULL, 'aigc_embed_store_delete', NULL, 5060, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5070, '会话消息管理', 'messages', NULL, '/aigc/messages/index', 5000, 'iconfont icon-gerenzhongxin', '1', 6, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-07-08 15:54:26', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5071, '新增', NULL, 'aigc_message_add', NULL, 5070, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5072, '删除', NULL, 'aigc_message_delete', NULL, 5070, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5100, '知识库管理', 'knowledge', NULL, '/aigc/knowledge/index', 5000, 'iconfont icon-gerenzhongxin', '1', 7, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-07-08 15:54:42', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5101, '新增', NULL, 'aigc_knowledge_add', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5102, '修改', NULL, 'aigc_knowledge_edit', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5103, '删除', NULL, 'aigc_knowledge_delete', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5104, '文件新增', NULL, 'aigc_doc_add', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5105, '文件修改', NULL, 'aigc_doc_edit', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5106, '文件删除', NULL, 'aigc_doc_delete', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5107, '文件切片新增', NULL, 'aigc_doc_slice_add', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5108, '文件切片修改', NULL, 'aigc_doc_slice_edit', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5109, '文件切片删除', NULL, 'aigc_doc_slice_delete', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5110, '向量新增', NULL, 'aigc_embedding_text', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5111, '向量上传新增', NULL, 'aigc_embedding_file', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5112, '向量重算', NULL, 'aigc_embedding_reEmbed', NULL, 5100, NULL, '1', 1, '0', NULL, '1', ' ', '2025-03-06 09:00:00', ' ', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_menu` (`menu_id`, `name`, `en_name`, `permission`, `path`, `parent_id`, `icon`, `visible`, `sort_order`, `keep_alive`, `embedded`, `menu_type`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5200, '智能助手', 'assistant', NULL, '/aigc/chat/index', 5000, 'iconfont icon-gerenzhongxin', '1', 9, '0', NULL, '0', '', '2025-03-06 09:00:00', 'admin', '2025-07-08 15:55:21', '0');


COMMIT;

-- ----------------------------
-- Table structure for sys_oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `sys_oauth_client_details`;
CREATE TABLE `sys_oauth_client_details` (
  `id` bigint NOT NULL COMMENT 'ID',
  `client_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户端ID',
  `resource_ids` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '资源列表',
  `client_secret` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '客户端密钥',
  `scope` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '域',
  `authorized_grant_types` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '认证类型',
  `web_server_redirect_uri` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '重定向地址',
  `authorities` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色列表',
  `access_token_validity` int DEFAULT NULL COMMENT 'token 有效期',
  `refresh_token_validity` int DEFAULT NULL COMMENT '刷新令牌有效期',
  `additional_information` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '令牌扩展字段JSON',
  `auto_approve` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否自动放行',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='终端信息表';

-- ----------------------------
-- Records of sys_oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `sys_oauth_client_details` (`id`, `client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `auto_approve`, `create_time`, `update_time`, `create_by`, `update_by`, `del_flag`) VALUES (1, 'app', NULL, 'app', 'server', 'app,refresh_token,sms', NULL, NULL, NULL, NULL, NULL, 'true', NULL, NULL, NULL, NULL, '0');
INSERT INTO `sys_oauth_client_details` (`id`, `client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `auto_approve`, `create_time`, `update_time`, `create_by`, `update_by`, `del_flag`) VALUES (2, 'fine', NULL, 'fine', 'server', 'refresh_token,authorization_code,captcha,password,sms', 'https://fine.life', NULL, 21600, 2592000, NULL, 'true', NULL, '2025-03-06 09:00:00', NULL, 'admin', '0');
INSERT INTO `sys_oauth_client_details` (`id`, `client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `auto_approve`, `create_time`, `update_time`, `create_by`, `update_by`, `del_flag`) VALUES (3, 'mall-app', NULL, 'mall-app', 'server', 'refresh_token,authorization_code,password,sms', 'http://localhost:80/sso/login', NULL, 43200, 2592001, NULL, 'true', NULL, NULL, NULL, NULL, '0');
INSERT INTO `sys_oauth_client_details` (`id`, `client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `auto_approve`, `create_time`, `update_time`, `create_by`, `update_by`, `del_flag`) VALUES (4, 'wechat', NULL, 'wechat', 'server', 'refresh_token,authorization_code,wechat', 'https://fine.life', '', 11111, NULL, '{\n	\"appName\":\"微信\"\n}', 'false', NULL, '2025-03-06 09:00:00', NULL, 'admin', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint NOT NULL COMMENT '编号',
  `log_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '日志类型',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日志标题',
  `service_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '服务ID',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT ' ' COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT ' ' COMMENT '修改人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remote_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '远程地址',
  `user_agent` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户代理',
  `request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求URI',
  `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求方法',
  `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '请求参数',
  `time` bigint DEFAULT NULL COMMENT '执行时间',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态',
  `trace_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'mdc跟踪ID',
  `exception` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '异常信息',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `sys_log_request_uri` (`request_uri`) USING BTREE,
  KEY `sys_log_type` (`log_type`) USING BTREE,
  KEY `sys_log_create_date` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='日志表';

BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称',
  `sort_order` int NOT NULL COMMENT '岗位排序',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否删除  -1：已删除  0：正常',
  `remarks` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新人',
  PRIMARY KEY (`post_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='岗位信息表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `sort_order`, `del_flag`, `remarks`, `create_time`, `create_by`, `update_time`, `update_by`) VALUES (1, 'cto', 'cto', 0, '0', '‌CTO‌是首席技术官（Chief Technology Officer）的缩写，是技术资源的行政管理者，负责企业的技术战略和方向。CTO的职责包括制订有关技术的愿景和战略，把握总体技术方向，监督技术研究与发展（R&D）的活动，并对技术选型和具体技术问题进行指导和把关，完成所赋予的各项技术任务/项目。', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '角色名称',
  `remarks` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '角色描述',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `create_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  `data_scope` tinyint(1) DEFAULT NULL COMMENT '数据权限范围',
  `data_scope_dept_ids` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '数据范围(指定部门数组)',
  `role_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '角色code',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `del_flag` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '删除标记',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`role_id`, `role_name`, `remarks`, `create_time`, `update_time`, `create_by`, `update_by`, `data_scope`, `data_scope_dept_ids`, `role_code`, `tenant_id`,`del_flag`) VALUES (1, 'admin', '超级管理员', '2025-03-06 09:00:00', '2025-03-06 09:00:00', NULL, 'admin', 1, NULL, 'SUPER_ADMIN', 1,'0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `remarks`, `create_time`, `update_time`, `create_by`, `update_by`, `data_scope`, `data_scope_dept_ids`, `role_code`, `tenant_id`,`del_flag`) VALUES (2, '普通用户', '普通用户', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin', 25, '', 'GENERAL_USER', 1,'0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `remarks`, `create_time`, `update_time`, `create_by`, `update_by`, `data_scope`, `data_scope_dept_ids`, `role_code`, `tenant_id`,`del_flag`) VALUES (3, '租户管理员', '系统生成租户管理员角色', '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'admin', 'admin', 1, NULL, 'TENANT_ADMIN', 1,'0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint NOT NULL,
  `menu_id` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='角色菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 4000);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 4001);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 4002);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1000);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1100);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1101);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1102);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1103);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1104);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1200);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1201);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1202);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1203);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1300);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1301);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1302);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1303);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1304);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1305);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1400);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1401);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1402);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1403);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1600);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1601);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1602);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1603);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1604);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1605);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1700);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1701);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1702);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1703);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1704);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1705);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 1800);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2000);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2001);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2100);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2101);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2102);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2200);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2201);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2202);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2203);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2906);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2907);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2210);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2211);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2212);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2213);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2214);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2215);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2800);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2810);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2820);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2830);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2840);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2841);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2850);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2851);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2860);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2870);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2871);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2400);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2401);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2402);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2403);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2600);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2601);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 4000);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 4002);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 4001);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5000);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5010);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5011);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5012);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5013);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5014);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5020);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5021);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5022);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5023);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5024);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5030);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5031);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5032);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5033);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5034);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5040);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5041);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5042);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5043);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5050);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5051);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5052);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5053);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5054);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5060);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5061);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5062);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5063);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5070);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5071);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5072);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5100);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5101);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5102);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5103);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5104);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5105);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5106);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5107);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5108);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5109);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5110);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5111);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5112);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5200);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9000);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9005);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9007);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2300);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9006);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9050);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9065);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9051);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9052);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9053);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9054);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9055);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9056);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9057);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9059);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9060);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9061);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9062);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9063);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 9064);
COMMIT;

-- ----------------------------
-- Table structure for sys_route_conf
-- ----------------------------
DROP TABLE IF EXISTS `sys_route_conf`;
CREATE TABLE `sys_route_conf` (
  `id` bigint NOT NULL COMMENT '主键',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `route_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `predicates` json DEFAULT NULL COMMENT '断言',
  `filters` json DEFAULT NULL COMMENT '过滤器',
  `uri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sort_order` int DEFAULT '0' COMMENT '排序',
  `metadata` json DEFAULT NULL COMMENT '路由元信息',
  `create_by` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT ' ' COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT ' ' COMMENT '修改人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='路由配置表';

-- ----------------------------
-- Records of sys_route_conf
-- ----------------------------
BEGIN;
INSERT INTO `sys_route_conf` (`id`, `name`, `route_id`, `predicates`, `filters`, `uri`, `sort_order`, `metadata`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (1, 'system模块', 'fine-system', '[{\"args\": {\"_genkey_0\": \"/admin/**\"}, \"name\": \"Path\"}]', '[{\"args\": {\"key-resolver\": \"#{@remoteAddrKeyResolver}\", \"redis-rate-limiter.burstCapacity\": \"100\", \"redis-rate-limiter.replenishRate\": \"100\"}, \"name\": \"RequestRateLimiter\"}]', 'lb://fine-system', 0, NULL, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_route_conf` (`id`, `name`, `route_id`, `predicates`, `filters`, `uri`, `sort_order`, `metadata`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (2, 'auth模块', 'fine-auth', '[{\"args\": {\"_genkey_0\": \"/auth/**\"}, \"name\": \"Path\"}]', NULL, 'lb://fine-auth', 1, NULL, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_route_conf` (`id`, `name`, `route_id`, `predicates`, `filters`, `uri`, `sort_order`, `metadata`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (3, '代码生成器模块', 'fine-codegen', '[{\"args\": {\"_genkey_0\": \"/gen/**\"}, \"name\": \"Path\"}]', NULL, 'lb://fine-codegen', 2, NULL, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_route_conf` (`id`, `name`, `route_id`, `predicates`, `filters`, `uri`, `sort_order`, `metadata`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (4, '定时任务模块', 'fine-quartz', '[{\"args\": {\"_genkey_0\": \"/schedule/**\"}, \"name\": \"Path\"}]', NULL, 'lb://fine-quartz', 3, NULL, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_route_conf` (`id`, `name`, `route_id`, `predicates`, `filters`, `uri`, `sort_order`, `metadata`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (5, '系统监控模块', 'fine-monitor', '[{\"args\": {\"_genkey_0\": \"/monitor/**\"}, \"name\": \"Path\"}]', NULL, 'lb://fine-monitor', 4, NULL, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_route_conf` (`id`, `name`, `route_id`, `predicates`, `filters`, `uri`, `sort_order`, `metadata`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (6, '消息服务模块', 'fine-message', '[{\"args\": {\"_genkey_0\": \"/message/**\"}, \"name\": \"Path\"}]', NULL, 'lb://fine-message', 4, NULL, 'admin', 'admin', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '0');
INSERT INTO `sys_route_conf` (`id`, `name`, `route_id`, `predicates`, `filters`, `uri`, `sort_order`, `metadata`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (7, 'Aigc服务模块', 'fine-ai', '[{\"args\": {\"_genkey_0\": \"/aigc/**\"}, \"name\": \"Path\"}]', NULL, 'lb://fine-ai', 4, NULL, 'admin', 'admin', '2025-07-08 09:24:13', '2025-07-08 09:24:13', '0');

COMMIT;
-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant` (
  `tenant_id` bigint NOT NULL AUTO_INCREMENT COMMENT '租户id',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '租户名',
  `tenant_admin_id` bigint DEFAULT NULL COMMENT '当前租户管理员id',
  `tenant_admin_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '当前租户管理员姓名',
  `tenant_admin_mobile` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '当前租户管理员手机号',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '租户状态（0正常 1停用）',
  `package_id` bigint NOT NULL COMMENT '租户套餐id',
  `expired_time` datetime NOT NULL COMMENT '过期时间',
  `account_count` int NOT NULL COMMENT '账号数量',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` bit(1) NOT NULL DEFAULT b'0' COMMENT '0-正常，1-删除',
  PRIMARY KEY (`tenant_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='租户表';

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant` (`tenant_id`, `name`, `tenant_admin_id`, `tenant_admin_name`, `tenant_admin_mobile`, `status`, `package_id`, `expired_time`, `account_count`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 'fine', 1, 'admin', '18764492968', 0, 1648145956129792001, '3000-01-01 00:00:00', 100, '1', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', b'0');
COMMIT;

-- ----------------------------
-- Table structure for sys_tenant_package
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant_package`;
CREATE TABLE `sys_tenant_package` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '套餐id',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '套餐名',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '套餐状态（0正常 1停用）',
  `remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注',
  `menu_ids` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联的菜单编号',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` bit(1) NOT NULL DEFAULT b'0' COMMENT '0-正常，1-删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='租户套餐表';

-- ----------------------------
-- Records of sys_tenant_package
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant_package` (`id`, `name`, `status`, `remark`, `menu_ids`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '租户套餐', 0, '', '12,4,5,6,7,21,29,100006,100009,100010,100011,100007,100008,100022,100025,100026,20,100024,100046,100021', 'admin', '2025-03-06 09:00:00', 'admin', '2025-03-06 09:00:00', b'0');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '登录名',
   `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `email` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '联系电话',
  `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '1' COMMENT '状态 0锁定 1有效',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '最近访问时间',
  `login_ip` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '登录IP',
  `sex` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '性别 0男 1女 2保密',
  `avatar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '头像',
  `remarks` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '描述',
  `create_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '更新人',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户id',
  `salt` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '加盐',
  `password_expire_date` datetime DEFAULT NULL COMMENT '密码过期日期',
  `user_sn` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '员工号',
  `del_flag` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `username`,`name`, `password`, `dept_id`, `email`, `phone`, `status`, `create_time`, `update_time`, `last_login_time`,`login_ip`, `sex`, `avatar`, `remarks`, `create_by`, `update_by`, `tenant_id`, `salt`, `password_expire_date`,`user_sn`,`del_flag`) VALUES (1, 'admin','admin', '{bcrypt}$2a$10$hicF.g9q2E3OLos3HqoXPO/Yqj2XKDq77qkadeluMOi5VS2nL19zC', 1, '', '18764492968', '0', '2025-03-06 09:00:00', '2025-03-06 09:00:00', '2025-03-06 09:00:00','127.0.0.1', '0', '', '超级管理员', 'admin', 'admin', 1,null,null,'10001','0');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `post_id` bigint NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`post_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户与岗位关联表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_post` (`user_id`, `post_id`) VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `USER_ID` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='用户角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`USER_ID`, `role_id`) VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_users_gitee
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_gitee`;
CREATE TABLE `sys_users_gitee` (
  `users_gitee_id` bigint NOT NULL AUTO_INCREMENT COMMENT '码云Gitee用户表主键，自增',
  `users_id` bigint DEFAULT NULL COMMENT '绑定的用户主键，唯一键：uk__users_gitee__appid__id__users_id',
  `app_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AppID(码云Gitee client_id)，唯一键：uk__users_gitee__appid__id',
  `id` int NOT NULL COMMENT '码云Gitee唯一标识，不为空，唯一键：uk__users_gitee__appid__id',
  `login` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '码云Gitee登录用户名，不为空',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '码云Gitee用户名，不为空',
  `avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '公开资料URL',
  `html_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '空间URL',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '企业备注名',
  `followers_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '粉丝URL',
  `following_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `gists_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `starred_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'star项目URL',
  `subscriptions_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '订阅项目URL',
  `organizations_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织URL',
  `repos_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '仓库URL',
  `events_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `received_events_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '接收事件',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '类型',
  `blog` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '博客地址',
  `weibo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微博地址',
  `bio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '自我介绍',
  `public_repos` int DEFAULT NULL COMMENT '公共仓库数',
  `public_gists` int DEFAULT NULL,
  `followers` int DEFAULT NULL COMMENT '粉丝数',
  `following` int DEFAULT NULL COMMENT '关注的人',
  `stared` int DEFAULT NULL COMMENT 'star数',
  `watched` int DEFAULT NULL COMMENT '关注的仓库',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮箱',
  `binding_date` datetime DEFAULT NULL COMMENT '绑定时间',
  `access_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '授权凭证',
  `refresh_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '刷新凭证',
  `expires` datetime DEFAULT NULL COMMENT '过期时间',
  `scope` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '授权范围',
  `company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '公司',
  `profession` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '职务',
  `wechat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微信',
  `qq` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'QQ',
  `linkedin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '领英账户',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间，不为空',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间，未更新时为空',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人，不为空',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人，未更新时为空',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '逻辑删除，0 未删除，1 删除，MySQL 默认值 0，不为 NULL，注解@TableLogic。',
  PRIMARY KEY (`users_gitee_id`) USING BTREE,
  UNIQUE KEY `uk__users_gitee__appid__id` (`app_id`,`id`) USING BTREE,
  UNIQUE KEY `uk__users_gitee__appid__id__users_id` (`app_id`,`id`,`users_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='码云Gitee用户表';

-- ----------------------------
-- Records of sys_users_gitee
-- ----------------------------
BEGIN;
INSERT INTO `sys_users_gitee` VALUES (1, 1, 'adc5f9f22929e7450749e4f04344132c', 7493281, 'cebsunits', 'admin', 'https://foruda.gitee.com/avatar/1682401752511923504/7493281_cebsunits_1682401752.png', 'https://gitee.com/api/v5/users/cebsunits', 'https://gitee.com/cebsunits', '', 'https://gitee.com/api/v5/users/cebsunits/followers', 'https://gitee.com/api/v5/users/cebsunits/following_url{/other_user}', 'https://gitee.com/api/v5/users/cebsunits/gists{/gist_id}', 'https://gitee.com/api/v5/users/cebsunits/starred{/owner}{/repo}', 'https://gitee.com/api/v5/users/cebsunits/subscriptions', 'https://gitee.com/api/v5/users/cebsunits/orgs', 'https://gitee.com/api/v5/users/cebsunits/repos', 'https://gitee.com/api/v5/users/cebsunits/events{/privacy}', 'https://gitee.com/api/v5/users/cebsunits/received_events', 'User', 'https://cebsunits.gitee.io/docs/', NULL, '', 84, 0, 59, 101, 215, 220, '2025-03-06 09:00:00', '2025-03-06 09:00:00', '112433877@qq.com', '2025-03-06 09:00:00', 'e0c3d4a6145e78e9c1dba7e4e83661fd', '9b80063e4e40c90989343130390357246d1dc201ce554968e6425bcf37b14d2b', '2025-03-06 09:00:00', 'user_info', NULL, NULL, NULL, NULL, NULL, '2025-03-06 09:00:00', '2025-03-06 09:00:00', 'anonymousUser', 'anonymousUser', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;